﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="RunSQLScript.aspx.cs" Inherits="ExpertMIS.Admin.AdminTools.RunSQLScript" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <style type="text/css">
        .style1
        {
            width: 100%;
        }
        .style2
        {
        }
        .style3
        {
            width: 120px;
        }
    </style>

    <script type="text/javascript">
        function doExecute() {
            return confirm('sure to execute?');
        }
    </script>

</head>
<body>
    <form id="form1" runat="server">
    <div>
        <table class="style1">
            <tr>
                <td class="style2" colspan="2" style="background-color: Navy; color: White">
                    Script Executor!!!
                </td>
            </tr>
            <tr runat="server" id="trErrorInfo" visible="false">
                <td class="style2" colspan="2" style="background-color: #000000; color: White">
                    <asp:Label runat="server" ID="lblError"></asp:Label>
                </td>
            </tr>
            <tr>
                <td class="style3">
                    Connection String
                </td>
                <td style="width: 100%;text-align:left;">
                    <asp:TextBox ID="txConnStr" runat="server" Width="90%"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td class="style3">
                    Script File
                </td>
                <td style="width: 100%;text-align:left;">
                    <asp:DropDownList ID="ddlScriptFiles" runat="server" Width="90%">
                    </asp:DropDownList>
                </td>
            </tr>
            <tr>
                <asp:Label ID="Label2" runat="server" Text="SQL Script"></asp:Label>
            </tr>
            <tr>
                <td colspan="2">
                    <asp:TextBox ID="txScript" runat="server" TextMode="MultiLine" Rows="60" Width="100%"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td colspan="2">
                    &nbsp;
                </td>
            </tr>
            <tr>
                <td colspan="2" style="text-align: center;">
                    <asp:Button runat="server" ID="btnRun" Text="Run" Width="100px" OnClientClick="return doExecute();"
                        OnClick="btnRun_Click" />
                </td>
            </tr>
        </table>
    </div>
    </form>
</body>
</html>
